How to set the background colour of the rows in a spreadsheet depending on the value of a cell in the row
Peter bill
How can I say,in Excel on the web: If cell F2 contains "Completed", set the background colour of row 2 to red?
There are lots of articles online (e.g.1, e.g.2) but they all seem to refer to desktop versions and require selecting Conditional Formatting → New Rule... .
My Excel on the web, part of Office 365, does not have a New Rule... command. I have a Manage Rules dialogue, but that only seems useful for deleting rules.
harrymc
The online version of Excel does have a Conditional Formatting button in the Home pane:
The method to use is very similar to that described for the Desktop version in the articles you have linked to.
For a detailed description with screenshots, see the article
How to Use Conditional Formatting in Excel Online
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Windows: keyboard shortcut to expand table columns
- Next: show/hide specific icon on windows notification area with command line
Related
Related Related
- 1
PHPExcel set font/background colour based on cell value
- 2
How to set datagrid row's background based on variably value in cell
- 3
Set table row background colour of td's with a specific value
- 4
Set an automatic color background depending on the HEX value in the cell?
- 5
How to set the background colour of a RadioButton?
- 6
How to set background colour for PsiJavaToken?
- 7
How to colorize a range in a row depending on a value in the first cell?
- 8
How to change background of DataGrid row depending on value in one column
- 9
How to change background of DataGrid row depending on value in one column
- 10
How to set background color in a row, when a cell has data over a specific value
- 11
Change cell font colour in a table depending on value - RoR
- 12
How to set DataGrid cell content depending on binding value?
- 13
How to set DataGrid cell content depending on binding value?
- 14
VBA Excel - Set row background depends on cell value
- 15
How to populate a cell depending on which rows mention the row's first cell
- 16
Copying and Pasting Row and Column Depending on cell value
- 17
How to automatically colour cell background with value selected from custom dropdown list in MS Excel 2010
- 18
Google spreadsheet - Colour rows if Strikethrough
- 19
How to set background for single cell of datagrid wpf not single row?
- 20
Set CSS rules depending the value of a table cell
- 21
How to change the colour of an MVC webgrid row text depending on some condition
- 22
How to change the colour of an MVC webgrid row text depending on some condition
- 23
How to set background colour when click on an item?
- 24
How to set background colour for header in TableView?
- 25
How to set the default background colour of a JButton?
- 26
How to Change the row Background color based on cell value
- 27
How to Change the row Background color based on cell value
- 28
How to set an array of integers to a spreadsheet cell?
- 29
How to set background color for a row based on current date in Google Docs Spreadsheet?
Comments