how to change color of the cell if value changes

  • Thread starter Thread starter kingu
  • Start date Start date
K

kingu

As the topic suggested I need help.
Lets say I have a numeric value in cell B14 on Sheet3. The value i
generated by COUNTIF from two other Sheets.
What I need to do is change the color of the value when I chang
something in the other Sheets to affect the value in B14 on Sheet3
Since I have like
50 cells which need to be checked it's just too annoying to do tha
every time if the value has indeed changed or not.
I think I need to use conditional formatting but I'm drawing a blan
here.

TIA

t
 
You need Conditional Formatting.

Select column A
Menu Format>Conditional Formatting
Add a conditional test as appropriate
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK
--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Maybe I'm still hung-over, or maybe I read the OP incorrectly, but I'd love
to see your example of a conditional test that'll monitor a change in a
cell, short of code.<g>
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

You need Conditional Formatting.

Select column A
Menu Format>Conditional Formatting
Add a conditional test as appropriate
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK
--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top