Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of a Row
I have a spreadsheet with a number of similar rows and I want to be able to
set the background colour of each row to cyan if the contents of cell Rx="Completed". Is there a simple way to do this other than setting up a conditional format entry for each individual cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of a Row
Select the range to apply the conditional formatting:
A2:X999 (say) Write your formula against the row with the activecell: =$r2="Completed" And apply your formatting. Mike McLellan wrote: I have a spreadsheet with a number of similar rows and I want to be able to set the background colour of each row to cyan if the contents of cell Rx="Completed". Is there a simple way to do this other than setting up a conditional format entry for each individual cell? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of a Row
Select the range you want to conditionally format, say A1:R100,
Use this formula in CF: =$R1="Completed" Regards, Stefi €˛Mike McLellan€¯ ezt Ć*rta: I have a spreadsheet with a number of similar rows and I want to be able to set the background colour of each row to cyan if the contents of cell Rx="Completed". Is there a simple way to do this other than setting up a conditional format entry for each individual cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |