I need to format (fill color) cells A-I if F and G have specific info
i tried conditional formatting but it doesn't allow for all my requirements.
So if cell F in any row has today's date (formatted at 7/16/2015) and cell G has "Awarded" then i need to highlight cells A thru I in that row.
I do have over 100 rows for it to parse.
I think something like this is what i am looking for but i am stuck on the actual function and where to put it.
if(f3=TODAY() & G3="Awarded") then....
try:
=AND(F1=ToDAY(),G1="Awarded")
If I've helped U pls click on d *Add Reputation
but where do i put the formula and how do i tell it to color the cells A thru I
go to home > conditional formatting > New Rule
under Rule Type select: Use a formula to determine which cells to format
paste the formula: =AND(F3=TODAY(),G3="Awarded")
in Format click Fill tab then choose the desired color
In the Applies To field type $A:$I
Let me know if it works.
ok it kinda worked... it formatted the dates in the f column but did not the rest of the row.... I need all cells in any row where F is today and G is Awarded. I have attached a screen shot.
can you delete all the other conditional format that applies to range A:I or click Stop if True beside the conditional format
the other formula that applies to F3 is deleted. However it is still not formatting all the cells in the rows where column f has today's date
the formatting will not apply because you have two conditions to satisfy.
F is today G is Awarded.
and please make sure you have the right formula:
=AND($F3=TODAY(),$G3="Awarded")
I can see in your 1st conditional format that the formula refers to A1=Today()
well thats what i am trying to do is if those 2 conditions met then cells A through I are formatted. Can it be done?
Yes if you just copy paste the correct formula which is:
=AND($F3=TODAY(),$G3="Awarded")
it is actually this formula
=AND($F1=TODAY(),$G1="Awarded")
Notice the $ signs. Thanks for your help
You're welcome.
Please mark this thread as Solved and adding a rep if you're satisfied with the solution.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks