Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting
How do I colour an individual cell based on the content
of another cell? Conditional formatting seems only to do this based on the content of the cell you want to conditionally colour. Or have I missed something? Best wishes, paul. |
#2
|
|||
|
|||
Paul
You have missed something. Select the cell for CF(say A1) FormatCFFormula is: =b1=123 Choose a format and OK your way out. When B1 is 123 A1 will be formatted. Gord Dibben Excel MVP On Tue, 21 Dec 2004 16:15:32 -0800, "Paul Orton" wrote: How do I colour an individual cell based on the content of another cell? Conditional formatting seems only to do this based on the content of the cell you want to conditionally colour. Or have I missed something? Best wishes, paul. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions |