Colour in Cell

[Shakes007]

Hi Everyone,
I am looking to fill cell A2 if B2 has data (dates) in it. I am trying to get on top of bills and when I enter the date of payment in B2 want it to fill A2 with colour so I can see what has and hasn't been paid. Please, help I have been trying all kinds to get this.
Thanks,

 

[etaf]

How about

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$B2 <> ""

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book10
	A	B
1
2
3		1/1/23
4
5
6
7		1/1/23
8
9
10
11		1/1/23
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A17	Expression	=$B2<>""	text	YES

 

[Shakes007]

How about

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$B2 <> ""

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Book10
	A	B
1
2
3		1/1/23
4
5
6
7		1/1/23
8
9
10
11		1/1/23
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A17	Expression	=$B2<>""	text	YES

Hi,
Thank you so much. I have now got the perfect table for the job.
Very clear instructions and very helpful snippets.
Again thank you

 

[etaf]

you are welcome