Conditional Formatting?

[Aussie Grid]

I remember seeing a workaround for being unable to conditionally format a referenced/calculated cell.
eg. A1 contains "Saturday"
A2 =A1
CF wont work on A2 as it reads as =A1while displaying " Saturday".
Delete A2's link to A1, type in "Saturday" and the CF works fine.

Any & all help appreciated.

TKU in advance
Aussie Grid

 

[meldoc]

Re: Conditional formatting problem

Hello

Works for me.

Excel Workbook
	A
1	Saturday
2	Saturday
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1="Saturday"	Abc
A2	1. / Formula is =A2="Saturday"	Abc

 

[Aussie Grid]

Re: Aussie Grid re Conditional Formating

Thanks meldoc but it doesn't work when in a range such as that below. I would like the weekends in the range B8 to B38 CF'd but it won't do it until the value in, say, B9(=B8+1) is deleted & Sat entered, which destroys all below of course.
I hope this makes it a bit clearer.
Aussie Grid
A1 1/01/2010
A2 Jan
A3 Fri


Jan-10

B8 Fri =A3
B9 Sat =B8+1
B10 Sun =B9+1
B11 Mon =B10+1
B12 Tue =B11+1
B13 Wed =B12+1

etc etc etc until the end of the month. Column C contains the date digit

 

[meldoc]

Re: Aussie Grid re Conditional Formating

Hello again

Try.

Excel Workbook
	A	B
1	01/01/2010
2	Jan
3	Fri
4
5
6
7
8		01/01/2010
9		02/01/2010
10		03/01/2010
11		04/01/2010
12		05/01/2010
13		06/01/2010
14		07/01/2010
15		08/01/2010
16		09/01/2010
17		10/01/2010
18		Etc.
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B8	1. / Formula is =WEEKDAY(B8,2)>5	Abc
B9	1. / Formula is =WEEKDAY(B8,2)>5	Abc

 

[Aussie Grid]

Re: Aussie Grid

Works perfectly.
Thank you very much meldoc.
Greatly appreciated

Aussie Grid

 

[meldoc]

Re: Aussie Grid

You are welcome

And BTW. I forgot, welcome to the board.

 

[Peter_SSs]

Re: Aussie Grid re Conditional Formating

Hello again

Try.

Excel Workbook
	A	B
1	01/01/2010	*
2	Jan
3	Fri
4	*	*
5	*	*
6	*	*
7	*	*
8	*	01/01/2010
9	*	02/01/2010
10	*	03/01/2010
11	*	04/01/2010
12	*	05/01/2010
13	*	06/01/2010
14	*	07/01/2010
15	*	08/01/2010
16	*	09/01/2010
17	*	10/01/2010
18	*	Etc.
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B8	1. / Formula is =WEEKDAY(B8,2)>5	Abc
B9	1. / Formula is =WEEKDAY(B8,2)>5	Abc

Why do the CF formulas in B8 and B9 both refer to B8?

 

[meldoc]

Re: Aussie Grid re Conditional Formating

Why do the CF formulas in B8 and B9 both refer to B8?

I don't know Peter, I hadn't spotted that, when I prepared the data in Jeanie, I selected the range A1:B18, and set the Analyse Range (Forum) limit to A1:B9, to include all relevant unique formulas, and after quick scan for column widths etc. I posted.
The formula that I learnt from yourself, was entered as "=WEEKDAY(B8,2)>5", into the conditional format range B8:17, I didnt copy paste or alter the range in any way, the method worked under testing here, so why it happened I can't say, a glitch in Jeanie?.