Conditional Formatting

[Number Cruncher 1969]

Good afternoon all,

I'm having a few issues with 'conditional formatting' I have it working partially!

What I'm trying to establish is when the date cell matches the current days date the whole row is highlighted. I can get the date cell highlighted but not the whole row.

Friday	01/05/2020​	400.00​
Saturday	02/05/2020​	500.00​
Sunday	03/50/2020​	200.00​

Hope this makes sense and thanks in advance
Clive

 

[Eric W]

Welcome to the forum. Try:

Book1
	A	B	C
1	DOW	Date	Amount
2	Friday	01/05/2020	400.00
3	Saturday	02/05/2020	500.00
4	Sunday	03/05/2020	200.00
5	Monday	04/05/2020	100.00
6	Tuesday	05/05/2020	200.00
7	Wednesday	06/05/2020	300.00
8	Thursday	07/05/2020	400.00
Sheet24

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C8	Expression	=$B1=TODAY()	text	NO

Select the whole range you want to highlight, and make sure to use the $ in front of the column reference with the date.

 

[Joe4]

Welcome to the Board!

Select the rows that you want affected by this Conditional Formatting.
Then, select the Formula option of Conditional Formatting, and write the formula as it applies to the very first row in your selection.

So, let's say that your first data row is row 2, and column B is your date column.
Then the CF formula would look like:
=$B2=TODAY()
Note that you need the dollar sign in front of the column reference to lock it down.

 

[GraH]

Hi,

[EDIT]: beaten in time by previous -)

Did you apply the rule on the whole range?

Book1
	A	B	C
1	fri	4/05/2020	400
2	sat	5/05/2020	500
3	sun	6/05/2020	784
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C3	Expression	=$B1=TODAY()	text	NO

 

[Number Cruncher 1969]

Welcome to the Board!

Select the rows that you want affected by this Conditional Formatting.
Then, select the Formula option of Conditional Formatting, and write the formula as it applies to the very first row in your selection.

So, let's say that your first data row is row 2, and column B is your date column.
Then the CF formula would look like:
=$B2=TODAY()
Note that you need the dollar sign in front of the column reference to lock it down.

Thank you this worked perfectly!!

 

[Number Cruncher 1969]

Thanks for all the comments this is now "Solved"

 

[Joe4]

You are welcome.
Glad we were able to help.