Sign in with
Sign up | Sign in
Your question

Excel formula help needed

Last response: in Applications
Share
October 26, 2010 9:00:10 PM

Hello,

I'm in need of an Excel expert, or just someone who knows better than I do how to put a formula together! I am trying to create a forumla to use with conditional formatting. What i need it to do is highlight a cell if two cells meet a certain condition.

For example;

IF
G1 = "S73"
AND
I1 = "OUTSTANDING"
Then Format cells (highlight in red)

If BOTH of the conditions in "" are not met, I dont want it to change

This will be applied across a whole sheet, is there a way to do this rather than copy and pasting the formula onto each row?

Hope someone can help as it would be a big time saver for me.

Thanks

Ash

More about : excel formula needed

November 11, 2010 2:40:41 PM

Hi,

Select from the Conditional Format the following:

Select Formula is from the Dropdown Listbox then enter the following:

=AND(G1="S73",I1="Outstanding")

Then select the format and choose you colour then click OK.

Tha's it!

Chuck
!