Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting
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 |
#2
|
|||
|
|||
Use conditional formating.
Select the whole row Set the condition Formula Is =$C$5="X" Choose the Format you want for the cells in that row. -- Regards Roger Govier "ESREI" wrote in 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 |
#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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |