Formating cells

Closed
shopkeeperrob Posts 1 Registration date Friday 25 April 2014 Status Member Last seen 25 April 2014 - 25 Apr 2014 à 10:30
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 25 Apr 2014 à 11:37
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 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
25 Apr 2014 à 11:37
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