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
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
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:
- Conditional formatting in Excel 2010
- Microsoft office 2010 free download - Download - Office suites
- Pdf and xps add in 2010 - Download - Other
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- Gif in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 17, 2014 at 03:27 PM
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
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 March 17, 2014
Status
Member
Last seen
March 19, 2014
Mar 19, 2014 at 03:10 PM
Mar 19, 2014 at 03:10 PM
Brilliant, it works perfectly, thank you!
