Highlight 1 cell based on 3 others

I have a spreadsheet that I want to work as follows.

A1 is highlighted red. A2 has text inputted, change A1 to orange. A3 has text inputted, change A1 to green.

It sounds so simple and probably is but I can't for the life of me figure it out.

Thank you.

Select A1, click on Conditional Formatting | New Rule | Use a formula... , then enter this formula in the dialogue box which pops up:

=AND(A1<>"",A2<>"")

Click on the Format button | Fill tab and choose orange, then OK your way out.

Repeat, but use this formula:

=AND(A1<>"",A3<>"")

then choose green for the fill colour.

Hope this helps.

Pete

I'm not sure whether I've explained it correctly. I'll do so again using the cells I am using.


It's a job schedule spreadsheet.

When A7 gets a job number, turn the cell to red.
When F7 gets a date entered, turn A7 to orange.
When I7 gets a date entered, turn A7 to green.

I've tried your solution but it's not done the trick.

=i7<>"" format green in conditional formatting select stop if true

=f7<>"", format orange in conditional formatting select stop if true

=a7<>"" format red select stop if true


chose stop if true for all formats

Neither fixes appear to be working.

Scrap that, it's worked.