conditional formating help

[rajjana]

how to create conditional formating formula for attached sheet

if colloms "Diff" and "E-BRC Date" filled that row will be highligh Green eles normal.


sry for bad english

[David A Coop]

Hi Rajjana,

Select the range A2:I7 and in the Conditional Formatting - select Use a formula to determine which cell to format

Enter =AND($H2>0,$I2>0) as the formula, and select the format (Fill = whatever colour you want).

Like this: rajjana - Conditional formating.xlsx

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".