Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based on adjacent cell?
I have a spreadsheet which needs a basic RAG format based on the cell
adjacent. For example column L contains the score, column M contains the empty box to be filled with colour based on the RAG status. It should be formatted as follows: Less than 18 = Green 18 = Amber 27 = Red I'm not sure how to link it to the adjacent cell? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting-Referencing adjacent cell | Excel Discussion (Misc queries) | |||
Conditional Formatting Based on Value of Adjacent Cell | Excel Discussion (Misc queries) | |||
Conditional Formatting based on adjacent cell value | Excel Discussion (Misc queries) | |||
Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) |