Formatting

brad1 · Apr 4th, 2002, 07:55 AM

I have a conditional format that the cell turns green if that data is equal to or less than a number in another cell. If the number is higher that the number in the same cell it turns red. How do I get the cells that are suppose to turn colors stay white if no data is in that cell?

Mark W. · Apr 4th, 2002, 08:02 AM

Quote:

On 2002-04-04 06:55, brad1 wrote:
I have a conditional format that the cell turns green if that data is equal to or less than a number in another cell. If the number is higher that the number in the same cell it turns red. How do I get the cells that are suppose to turn colors stay white if no data is in that cell?

Change your "green" condition to...

=AND(A2<=B2,ISNUMBER(B2))

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 07:55 AM	#1
brad1 New Member Join Date: Mar 2002 Posts: 4	I have a conditional format that the cell turns green if that data is equal to or less than a number in another cell. If the number is higher that the number in the same cell it turns red. How do I get the cells that are suppose to turn colors stay white if no data is in that cell?