Conditional Formatting cells

A

AlanN

I have used this feature through varying complex situations. I am running
into problems when I try to format the resultant value "Sat" and "Sun" a
color of my choice.

In Column A (starting at A12) I have the dates 1/1/2004 to 12/31/2004.
In offsetting column B I have the formula (starting in B12)
"=TEXT(WEEKDAY(A12), "ddd")"
I cannot seem to format all the cells where the result of "Sat" or "Sun" to
have a fill color of my choice. Can anyone tell me what the formula should
be - after selecting the range a12:a376 ?
TIA, Alan
 
H

Hank Scorpio

Sorry... I meant to say "after selecting the range B12:B376 ?
Click to expand...

Formula Is

=OR(B12="Sat",B12="Sun")

Note that because the references are in relative format (no $ signs)
the formula will automatically adjust itself over the selected range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

expanding on sumproduct command to add all cases 9
Conditional Formatting of rows on a calendar 1
Formula Help / Worksheet Help 1
A calculation to count all cells ='D' where the offset cells in range have dates <= todays date 2
Changing Multiple Cell Formulas 3
Find the first & subsequent cells to contain text in a column & re 28
Weekend dates conditional format 3
calculating years months days hours minutes and seconds 4

Top