Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hi, i need a formula to add in conditional formatting, that will change the
color of a cell if a certain condition is met. I have a table with datas. I need to change the patter color of the rows (rangeA:G) if G is emty. I need to change the color only if the above and below cells are not empty Ex: D 1 john 2 john 3 4 john i need the empty row (A:G) to be blue Can this be done? Thanks! |
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 |