| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
