Is this conditional formatting or something else?

[lero1324]

Hey all,
There’s something I was wanting to do with our QC checklist, and I’d like your help with it.

Essentially the idea is to have the cells conditionally formatted so that If cell J15= Y the all the cells to the right (M15,V15,AE15,AJ15,AM15 and AP15) will have a red fill until it is no longer blank. If cell J15=N then all the cells with the exception of cell AP15 will be blank (and no fill) and cell AP15 will have a red fill until it is no longer blank.
If cell A15 has a date entered then again all cells to the right will have a red fill until cells C15, G15 and J15 are no longer blank.

Is this something I can accomplish with conditional formatting or something else?



Any help or push in the right direction would be greatly appreciated.

 

[onlyadrafter]

Hello,

select M, V, AE, AJ, AM and AP, select conditional formatting, add a rule and enter this formula:

=AND($J15="Y",M15="") and format as required.

select J and AP and as above but enter this formula

=AND($J15="",$AP15="") format as required.

Is what you expect?