Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John

Select C29
From menu FormatConditional FormattingCondition1
Formula Is
=AND(N410,N41<=1594)

Select a color to highlight

If this post helps click Yes
---------------
Jacob Skaria


"Very Basic User" wrote:

Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John

Select C29 and go to Format|Conditional Formatting and select Formula Is
from the 1st drop down menu.

Enter formula: =$N$41<=1594

Click Format and choose from the Pattern tab .


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113010

Hi,
select C29, then conditional formating,where the formula is =N41<=1594,
choose your colour


"Very Basic User" wrote:

Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John

Thank you! very easy fix!
--
Thank you for your time!
John


"Jacob Skaria" wrote:

Select C29
From menu FormatConditional FormattingCondition1
Formula Is
=AND(N410,N41<=1594)

Select a color to highlight

If this post helps click Yes
---------------
Jacob Skaria


"Very Basic User" wrote:

Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John

Select C29, click Format/Conditional Formatting from the menu bar, select
"Formula Is" from the first drop down box and put this formula in the blank
field that shows next to it...

=AND(C29<=1594,C29<"")

Now click the Format button and select the Patterns tab on the next dialog
box that appears... choose a color for the cell and then OK your way back to
the worksheet. That cell should now do what you want.

--
Rick (MVP - Excel)


"Very Basic User" wrote in message
...
Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John

Rick --

I'm trying to do something similar jwith 3 different color coding options.
I've tried setting multiple target parameters using IF functions and 3
conditional formats, but it doesn't seem to be working. I.E., in cell B36 --

*If the value in cell H3 is 60, I want B36 to turn green, OR
*If the value in cell H3 is <60, but 30, I want B36 to turn yellow, OR
*If the value in cell H3 is <30, I want B36 to turn red

Any ideas?

"Rick Rothstein" wrote:

Select C29, click Format/Conditional Formatting from the menu bar, select
"Formula Is" from the first drop down box and put this formula in the blank
field that shows next to it...

=AND(C29<=1594,C29<"")

Now click the Format button and select the Patterns tab on the next dialog
box that appears... choose a color for the cell and then OK your way back to
the worksheet. That cell should now do what you want.

--
Rick (MVP - Excel)


"Very Basic User" wrote in message
...
Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say... If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this be
done?
--
Thank you for your time!
John

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"Leona" wrote in message
...
Rick --

I'm trying to do something similar jwith 3 different color coding options.
I've tried setting multiple target parameters using IF functions and 3
conditional formats, but it doesn't seem to be working. I.E., in cell
B36 --

*If the value in cell H3 is 60, I want B36 to turn green, OR
*If the value in cell H3 is <60, but 30, I want B36 to turn yellow, OR
*If the value in cell H3 is <30, I want B36 to turn red

Any ideas?

"Rick Rothstein" wrote:

Select C29, click Format/Conditional Formatting from the menu bar, select
"Formula Is" from the first drop down box and put this formula in the
blank
field that shows next to it...

=AND(C29<=1594,C29<"")

Now click the Format button and select the Patterns tab on the next
dialog
box that appears... choose a color for the cell and then OK your way back
to
the worksheet. That cell should now do what you want.

--
Rick (MVP - Excel)


"Very Basic User" wrote in
message
...
Sorry for the blank post, I hit enter to move to this box...

Here is my question. I have a spreadsheet where I want "C29" to say...
If
"N41 is <= 1594 then shade C29 to red if not leave it normal. Can this
be
done?
--
Thank you for your time!
John