Conditional Formatting Based on another cell

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
Hello,

I'm trying to make a budget spreadsheet and want to format the cells if there is an omission.

If a value has been entered into cell C3 (for example) and it hasn't been entered whether it has been paid or not into cell D3 (so if a cell in column C has a value and it's corresponding D cell hasn't), I want to make the cells red.

Thanks!

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Hannah, Good afternoon.

Select C3:D3
Menu --> Conditional Format --> Use Formula
=OR($C3=0,$D3=0)
Select Format color as you desire.
OK

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão