Previous Topic Next Topic

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
Related:

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
Answer 2 / 2
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses