If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding fill to cells only when value is "No" in another cell
I would like to apply a conditional format to a selection of cells that will
change the fill to gray when the value in another cell = "No". So, let's say "No" was input into cell A1, if so then cells B1 through E1 would automatically fill with gray. If the value in A1 is blank or "Yes" or anything else, then no formatting would occur in those cells because data would need to be input in them. Is it possible to do this? |
#2
|
|||
|
|||
Adding fill to cells only when value is "No" in another cell
In B1, create a conditional format of:
=$A$1="No" and set the fill to gray. Now copy the format of B1 down to E1 (right-drag the fill handle and choose Fill Formatting Only). Regards, Fred "Noel" wrote in message ... I would like to apply a conditional format to a selection of cells that will change the fill to gray when the value in another cell = "No". So, let's say "No" was input into cell A1, if so then cells B1 through E1 would automatically fill with gray. If the value in A1 is blank or "Yes" or anything else, then no formatting would occur in those cells because data would need to be input in them. Is it possible to do this? |
Thread Tools | |
Display Modes | |
|
|