AXISHK
asked on
Excel Conditional Format
How to configure a conditional format on the attached worksheet such than any value in column B will be highlighted if it's value is smaller than that in Column C
Tks
Template.xlsx
Tks
Template.xlsx
ASKER
Not sure what's wrong on my Excel. I have put the conditional format on Column R and compare the value on S2. However, it doesn't row the correct row.
Any idea ?
Tks
test.xlsx
Any idea ?
Tks
test.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks
you could use =B2<C2
Regards
Templatev1.xlsx