Conditional formatting set up

[John Louis]

Hi everyone,
i have a worksheet and would like to apply conditional formatting for the rows and columns below any input is appreciated very much.
I want this to be applied to my entire worksheet & also to work if I add rows.

If my first cell A3 (& for all rows in column A)is greater than zero, turn columns D,N,O,P,Q,R,S for that corresponding row to yellow.

The last thing I would like to do is...Once cell S3 (& for all rows in column S) is populated with a date turn the columns we turned to yellow above to " no fill"

thanks very much.

 

[Joe4]

Follow these steps:
1. Highlight the following columns (the entire column): D,N,O,P,Q,R,S
2. Go to Conditional Formatting and select the "Use a formula to determine which cells to format" option
3. Enter the following CF formula:
=AND($A3>0,$S3=0)
4. Choose the yellow fill option

This should do what you want.

 

[John Louis]

Hi Joe,
thanks very much that formula worked like a champ!! I really appreciate your help.

Thanks John