CF conditional on other cell value

[isildad]

I want to fill A1 with yellow IF cell B10 is not populated
Tried in CF formula: =IF(B10)=0

 

[Beate Schmitz]

Hello,

Excel Workbook
	A	B
1	5
2
3
4
5
6
7
8
9
10
Sheet

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =B10=""	Abc

 

[ageren]

try conditional formatting task..

select column B > click format > click conditional formatting > fill the conditions as you wish..

 

[isildad]

Probably both answers are correct but I cannot understand ... pls more details

 

[isildad]

Got it:
In A1 do CF and formula is:
=$B$10=""