Conditional formatting in Excel 2010

Closed
Report
Posts
2
Registration date
Monday March 17, 2014
Status
Member
Last seen
March 19, 2014
-
Posts
2
Registration date
Monday March 17, 2014
Status
Member
Last seen
March 19, 2014
-
Hi, I'm wondering if there is a way to tell Excel use conditional formatting on a cell when/if another cell has conditional formatting to it.
Basically I can apply conditional formatting to a cell to say that when a date is entered it turns a certain color but what I'm hoping to do is to turn a row of cells into one colour.

For example if cell A1 has a date entered then called A1:A10 should all turn blue

In cells A2 to A10 are a mix of text, dates and numerical data, is this possible? Is there a way to say if cell A1 turn blue then A2:A10 turn blue too?
Thank you!

Galaxy

2 replies

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
galaxynut, Good afternoon.

Try to do:
--> Select A1:A10
--> Menu Conditional format
--> New Rule --> Using formula

Formula --> =$A$1<>0
Use a format colour that you prefer.
OK

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
2
Registration date
Monday March 17, 2014
Status
Member
Last seen
March 19, 2014

Brilliant, it works perfectly, thank you!