Excel 2007 : Conditional Formatting issue concerning colors
Closed
Geoff84
Posts
2
Registration date
Thursday January 15, 2015
Status
Member
Last seen
January 15, 2015
-
Jan 15, 2015 at 05:38 AM
RayH - Jan 15, 2015 at 04:03 PM
RayH - Jan 15, 2015 at 04:03 PM
Related:
- Excel 2007 : Conditional Formatting issue concerning colors
- Save as pdf office 2007 - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
What rule are you using to achieve what you have done so far?
What range are you applying the formatting to?
Surely you can just expand this range to cover what you need?
Make sure you are using $.
e.g. using the formula rule type
=$A$9="x"
So when cell contains "x" the whole range applied gets the desired format.
What range are you applying the formatting to?
Surely you can just expand this range to cover what you need?
Make sure you are using $.
e.g. using the formula rule type
=$A$9="x"
So when cell contains "x" the whole range applied gets the desired format.
