duteberta
Board Regular
- Joined
- Jun 14, 2009
- Messages
- 92
- Office Version
- 365
- Platform
- MacOS
I'm struggling to find the write formula to write in Conditional Formatting to highlight ONLy the last cell in each column that has a value but only on the condition that a value above is met.
So in my case if the value in Row 6 = "YES" then highlight the last cell in that column that has a value. I tried using this to no avail...
=IF(C$6="YES",COUNTA($C$5:$C$999)=ROW($C11))
Here is a screenshot of what I'm working on...
So in my case if the value in Row 6 = "YES" then highlight the last cell in that column that has a value. I tried using this to no avail...
=IF(C$6="YES",COUNTA($C$5:$C$999)=ROW($C11))
Here is a screenshot of what I'm working on...