Conditional Formating

[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

 

[J.E. McGimpsey]

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.