Excel 2007 : Conditional Formatting issue concerning colors
Closed
Geoff84
Posts
1
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
Dears,
I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell.
Does anyone have an idea how to do this?
Thanks in advance
Geoffrey
I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell.
Does anyone have an idea how to do this?
Thanks in advance
Geoffrey
Related:
- Excel 2007 : Conditional Formatting issue concerning colors
- Save as pdf office 2007 - Download - Other
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
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.