Color each row in RED,GREEN or GRAY if B1/C1/D1 is not blank.

Hello everybody,

I can’t figure out how to do something in excel.

 

I am using 23000 rows and each row has 4 columns.

On each row there will be two columns with data.

The first will always be column A, and the secon could either be B,C or D.

 

I want to crate the following condition for each row:

 

If B1 is not blank, then color A1-D1 green.

If C1 is not blank, then color A1-D1 red.

If D1 is not blank, then color A1-D1 gray.

 

If B2 is not blank, then color A2-D2 green.

If C2 is not blank, then color A2-D2 red.

If D2 is not blank, then color A2-D2 gray.

 

and this has to be active for all 23000 rows.

 

Could you please help out?

 

Best regards,

Kalin

By: Kalin

Leave a Reply

Your email address will not be published. Required fields are marked *