| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting to test blank text cell
I am trying to satisfy 2 criteria in order to change the color of a cell:
I hilighted cells b27:b56) and then went to conditional formatting and entered this formula. I want the b column to turn blue if the adjacent cell in the C column is greater than zero. I am spinning my wheels on this. Thanks in advance for your help. You folks always come through for me! =and(c17:c560,isblank(b17:b56)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| put zero in blank cell using conditional formatting | Excel Worksheet Functions | |||
| Multiple formatting in text cell blank it out! | Excel Discussion (Misc queries) | |||
| Conditional Formatting to Test Value in Cell | Excel Worksheet Functions | |||
| Multiple-Test Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
