Conditional Formatting based on multiple cells

billiamb · billiamb's Computer Specifications

I am trying to make cell A1 turn red if either A3 or B1 or C2 or D4 have the text Avg > 0.5%. I have tried this in cell A1 - Format - Conditional Format - Formula is =IF(OR(A3="Avg > 0.5%", B1="Avg > 0.5%", C2="Avg > 0.5%", D4="Avg > 0.5%")) but Excel complains. Could someone please show the proper format for this conditional format? Thank-you in advance!

Stoneboysteve · Stoneboysteve's Computer Specifications

billamb,

The formula for IF looks for the logical test, the result if true, the result if false. If you put the formula in the cell Excel will prompt you for values. I imagine the complaint from Excel is that the formula is not complete.

Stoneboysteve

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Based of Cells Based on Data Entry in anoth	Jim	Microsoft Excel Misc	3	11th Nov 2008 11:52 PM
Re: Conditional Formatting Based on two cells in a row	ljasonmiller@gmail.com	Microsoft Excel Worksheet Functions	2	18th May 2007 03:49 PM
Conditional Formatting Multiple cells based on 2 cells	=?Utf-8?B?TG91aXMgTWFya293c2tp?=	Microsoft Excel Worksheet Functions	2	1st Jun 2005 05:26 PM
Conditional formatting based on other cells value	Rasmus	Microsoft Excel Worksheet Functions	2	21st Aug 2003 12:32 AM
Conditional Formatting based on 2 cells	Shane Clarke	Microsoft Excel Worksheet Functions	4	11th Jul 2003 03:29 AM