Formating cells [Closed]

Report
Posts
1
Registration date
Friday April 25, 2014
Status
Member
Last seen
April 25, 2014
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
i am trying to change the colour of a cell based on the value of two other cells in Excel 2010.

for example
if R1 is the same value as C6 how do i change the formating in cell R6 so that the shading is a different colour?

R6 already has a formula in it so i am hoping to do this using conditional formating

1 reply

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
shopkeeperrob,Good morning.

Try to use it.

--> Select R6
--> Conditional formating
--> use formula =R1=C6
--> choose your layout/colours

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão