Formatting in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if col a12 is todays date I would like to have b2 to cz2 backgroundcolor GREEN
otherwhise leave B2 to cz2 as white background.
I cannot seem to get it to work Any help wouldbe appreciated
Thanks
 
I assume you are using Conditional Formatting? What conditions have you
tried? Have you remembered that CF gives you the choice between "Cell Value
Is" and "Formula Is"? The latter is usually the one to use if you are
trying to format one cell based on the content of another. Remember to
think about the difference between relative and absolute addressing if you
are trying to apply a formula to more than one cell. Remember also that CF
has a nasty habit od second-guessing what you intended to put in your
formula (particularly if you didn't include the leading = sign), so it's
always worth going back into CF to check that the condition it is showing is
the one you intended.
 
Select B2 thru CZ2, on the Home tab, styles section, click conditional
formatting and then New rule...
Select Use a formula to determine which cells to format and enter this
formula:
=$A$12=TODAY()
Click the format button, the fill tab, and choose your favorite shade of
green.
Click ok and ok to return to your sheet.
Your range will only turn green when A12 contains the same date as the
current date according to your computer.
 
Just what I was looking for..
Many Thanks

BoniM said:
Select B2 thru CZ2, on the Home tab, styles section, click conditional
formatting and then New rule...
Select Use a formula to determine which cells to format and enter this
formula:
=$A$12=TODAY()
Click the format button, the fill tab, and choose your favorite shade of
green.
Click ok and ok to return to your sheet.
Your range will only turn green when A12 contains the same date as the
current date according to your computer.
Click to expand...
 
Back
Top