Conditional Formatting - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

BoredBloke replied

18 June 2014, 11:10
Originally posted by Netraider View Post

I am hoping some Excel geeks can help me with an issue I am having with Excel conditional formatting.I have two cells (A3 and A5 for example). Cell A6 has the product of those 2 cells. Using conditional formatting to apply colour is fairly simple, however I do have conditions where I need the conditional formating to be based on the contents of A3 and A5.In english what I want to produce as a conditional format is...IF A6=4 AND A3 OR A5=4 then apply conditional format.Any suggestions or ideas gratefully accepted.

In Cell A6 - Use Formula to determine which Cells to Format
Formula is
=AND($A$6 = 4, OR($A$3=4,$A$5=4))
Leave a comment:
Netraider started a topic Conditional Formatting

18 June 2014, 11:03
Conditional Formatting

I am hoping some Excel geeks can help me with an issue I am having with Excel conditional formatting.I have two cells (A3 and A5 for example). Cell A6 has the product of those 2 cells. Using conditional formatting to apply colour is fairly simple, however I do have conditions where I need the conditional formating to be based on the contents of A3 and A5.In english what I want to produce as a conditional format is...IF A6=4 AND A3 OR A5=4 then apply conditional format.Any suggestions or ideas gratefully accepted.
Tags: None

Working...

X