Conditional formatting in Excel 2010

Closed
galaxynut Posts 2 Registration date Monday 17 March 2014 Status Member Last seen 19 March 2014 - 17 Mar 2014 à 15:16
galaxynut Posts 2 Registration date Monday 17 March 2014 Status Member Last seen 19 March 2014 - 19 Mar 2014 à 15:10
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
Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
17 Mar 2014 à 15:27
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
galaxynut Posts 2 Registration date Monday 17 March 2014 Status Member Last seen 19 March 2014
19 Mar 2014 à 15:10
Brilliant, it works perfectly, thank you!