Previous Topic Next Topic

Formating cells

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

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 25, 2014 at 11:37 AM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Excel function question
1234ah -
ac3mark -

3 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response