Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a conditional format formula that says if D1 = "N" than cells B1&C1
should be gray. What should I type in the conditional format statement? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select B1:C1, then apply CF using formula is: =$D1="N"
Format to suit, ok out -- Max Singapore --- "Pass-the-Reality" wrote: I need a conditional format formula that says if D1 = "N" than cells B1&C1 should be gray. What should I type in the conditional format statement? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |