Conditional formatting in Excel 2010

Closed
galaxynut Posts 2 Registration date Monday March 17, 2014 Status Member Last seen March 19, 2014 - Mar 17, 2014 at 03:16 PM
galaxynut Posts 2 Registration date Monday March 17, 2014 Status Member Last seen March 19, 2014 - Mar 19, 2014 at 03:10 PM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Mar 17, 2014 at 03:27 PM
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
0
galaxynut Posts 2 Registration date Monday March 17, 2014 Status Member Last seen March 19, 2014
Mar 19, 2014 at 03:10 PM
Brilliant, it works perfectly, thank you!
0