Conditional Formating

  • Thread starter Thread starter Imran Malik
  • Start date Start date
I

Imran Malik

Hi All.
I need help regarding conditional formating in Excel XP, so that i need that
I want to format say, cell C5 but i want that when i change some
value,either manually or by some formula in cell say, C4, then, conditional
formatting should be applicable in C5.i.e, indirectly, C5 should be changed
Thanks
 
One way:

Say your condition is that if C4<0 then C5 should be red. Select C5,
choose Format/Conditional formatting , and set your dropdowns and
textboxes to read

Formula is =C4<0

then click Format, choose red from the Patterns tab, then OK, OK.
 
Back
Top