change color and value of cell by formula

**jurjon** · 09-12-2006, 06:49 AM

Helo,

How can I change color of cell depends on value

example:

If in cell A1 I type number 12, I want that this cell fill in red color

Thanks
Jurate

**VBA Noob** · 09-12-2006, 06:58 AM

Hi,

Try Format > condtional formats > cell value = 12. Adjust formats as required

VBA Noob

**teelim** · 09-12-2006, 11:00 AM

Originally Posted by VBA Noob

Hi,

Try Format > condtional formats > cell value = 12. Adjust formats as required

VBA Noob

This only works for 3 cases (Only upto 3 Conditional Formating per cell).

If you need more than 3 colours, you need to look for other methods, else this should work fine

change color and value of cell by formula

LinkBack

Thread Tools

Rate This Thread

Display

change color and value of cell by formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions