Conditional Formating

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting code 1
Change the colour of a cell if another named cell is blank 2
Calculate end date and time 1
#REF! 1
Using IF, AND and OR functions together 2
conditional formating in adjacent cells 2
Conditional formatting multiple cells from one cell to another 3
Conditional Formating 1

Top