Help with conditional formatting

[Pharmacisticus]

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]

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

 

[Fluff]

Another option.
Select C6:I91
In CF > New rule > use a formula > =$H6>$I6 select format > OK
& the same with the formula
=$H6<$I6