Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
1. Select your range.
2. Go to Format Conditional Formatting 3. Select "Formula Is" and put: =INDIRECT("rc",0)="x" 4. Press the Format radio button and format as desired. HTH Jason Atlanta, GA -----Original Message----- Can I do a conditional formatting on a range if the value in one cell in the range = X in other words can I format the back ground for line 5 if C5 = X . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |