Hi all,



how do i apply conditional formatting where i want to highlight and compare numerical value between 2 cells

so lets say we have a table and we have the values in B2 =3 and C2= 2
How should i put a rule that will highlight the cell in that row (or column) with the highest (or lowest) value.

How is that achieved?

Hello
Select the range to format ( say B2:C2)
Home ribbon
Styles tab
Cond formatting
Click " manage rules" - New rule - Use a formula
Enter OK

Format as required -Finish

EDIT Replace MAX with MIN if needed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

this doesn't work..



i did exactly what you said but both cells both B2 and C2 were filled.

maybe i didn't explain what i want.

let's say i want to put data for 2 contestants. Then i need to highlight(by formatting) the higher value for each characteristic.

for example height b2: 1,68 c2: 1,75 ! i want cell C2 to be highlighted

highlight B2 and C2 go conditional format / formula is
and format your colour

My mistake
should be
See attached

Attached Files

CF.xlsx (12.3 KB, 9 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post