Conditional Formatting (Hightlight row based on one condition)
one way:
Select columns A-D, with A1 as the active cell. Choose
Format/Conditional Formatting and use the dropdowns and input box to
enter:
CF1: Formula is =$A1=$E1
Format1: <patterns/<your color here
In article ,
Jamesy wrote:
Hi,
I've looked through the conditional formatting section but can't find
anything.
Here is my problem...
A B C D E
1 DD SS WW 1
2 SS QQ EE 4
Now what I require is for section A1-D1 to highlight in red when A1=E1, so
for my example I would only expect to see one row highlighted because there
is only one match.
Your help again is much appreciated.
Regards,
James.
|