Help with conditional formatting

Pharmacisticus

New Member
Joined
Sep 12, 2018
Messages
11
https://drive.google.com/open?id=1iyKH3DkICLzOlxux7EhmLkuyx_ljMCZc

Hi All,

Can someone please help me with what I think is conditional formatting?

I have included in the above link a copy of the worksheet I am on.

What I would like to do is highlight the rows based onthe contents of columns H (Your Result %) and I (Comparison result %).
Where column H is greater than column I , the row shouldbe coloured light green, where column H is less than column I , the row shouldbe coloured red.
I would like this applied on all rows from 6 – 91.
Is this possible?
I’ve tried with conditional formatting but it’s notworking for me…
Kind Regards,
Pharmacisticus


 

orsm6

Board Regular
Joined
Oct 3, 2012
Messages
149
you'll basically need two conditional formats to do this.... i am unable to load pictures and stuff to help so hopefully you can follow this.

select H6
FORMAT 1
insert new conditional format rule
choose "format only cells that contain"
select - cell value
select - less than
type =I6 in the field
Format the colour to red
click OK

select H6
FORMAT 2
insert new conditional format rule
choose "format only cells that contain"
select - cell value
select - greater than
type =I6 in the field
Format the colour to green
click OK

select I6
FORMAT 3
insert new conditional format rule
choose "format only cells that contain"
select - cell value
select - less than
type =H6 in the field
Format the colour to red
click OK

select I6
FORMAT 4
insert new conditional format rule
choose "format only cells that contain"
select - cell value
select - greater than
type =H6 in the field
Format the colour to green
click OK


cell H6 will have 2 formats
cell I6 will have 4 formats when finished

to copy it to each row, highlight H6:I6, press ctrl + C
select the cells below down to row 91
right click, choose paste Formatting
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,427
Office Version
365
Platform
Windows
Another option.
Select C6:I91
In CF > New rule > use a formula > =$H6>$I6 select format > OK
& the same with the formula
=$H6<$I6
 

Forum statistics

Threads
1,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top