Previous Topic Next Topic

Conditional Formatting Based on another cell

Closed
Hannah - 4 Jul 2015 à 15:00
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 4 Jul 2015 à 16:32
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 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
4 Jul 2015 à 16:32
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses