#### peterv6

##### Board Regular

- Joined
- May 16, 2005

- Messages
- 128

- Office Version
- 365

I want to conditionally format the cells in column A depending on the values in the corresponding cells of a different columns, say columns B & C.

Column A would have dates.

Columns B & C would have number values representing hours and minutes in decimal form.

A B C

1/1/2022 0.50

1/2/2022 0.75

1/3/2022 1.50

1/4/2022 3.00

1/5/2022

1/6/2022 1.25

1/7/2022

If a cell in column A has a non-blank value in column B, I'd want the value in the cell in column A to be colored Green.

If a cell in column A has a non-blank value in column C, I'd want the value in the cell in column A to be colored Red.

If the values in both columns B & C are blank, I'd leave the formatting in the corresponding cell in column A the default color.

On an individual basis, I can do this using conditional formatting, but is there any way to apply this to an entire column?

I know how to do that with copy & paste for individual cells, but I can't figure out how to do it for an entire column based

on the cells in a corresponding column. If anyone can tell me if this is possible, and give me an idea how to do it, I'd be

eternally grateful. TIA