| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding colour to a range of cells based on one of the cells v...
I wish to highlight all the data in a row in a particular colour depending on
the value of one of the cells i.e. if cell c3 says 'confirmed' I would like all the entries in row 3 to be green, if it says 'released', then red, etc. So far I can change the word 'confirmed' in c3 to green, or to red for 'released', but can't work out how to change the rest of the row based on this value. Any help very welcome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
| How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Threaded Mode
