Posted to microsoft.public.excel.misc

Dave

external usenet poster

Posts: 27

Conditonal Format Problem

I have a set of data:

A B
Car1 12
Car2 19
Car1 11
Car3 31
Car1 9
Car2 22

I need column B to flash up RED if Car1 is 10 or less, Car2 is 20 or
less and if Car3 is 30 or less. I have no idea where to even start on
the formulas.

If anyone can help it would be great.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditonal Formula	flyers5182	Excel Discussion (Misc queries)	7	February 5th 07 09:17 PM
Pivot Table Conditonal Format of the Grand Total	michelle	Excel Worksheet Functions	3	November 2nd 06 11:39 PM
Conditonal Formatting	Matt	Excel Discussion (Misc queries)	3	April 21st 06 07:42 PM
Conditonal Format Formula	Yogi_Bear_79	Excel Worksheet Functions	5	June 3rd 05 05:35 PM
Conditonal Format with a date format	Kevin	Excel Discussion (Misc queries)	2	April 27th 05 10:20 PM

All times are GMT +1. The time now is 12:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us