Geek Girl 007
Board Regular
- Joined
- Mar 12, 2022
- Messages
- 183
- Office Version
- 2021
- Platform
- Windows
I want Cells A4 through to F6 to go another colour if cells C4 though to F6 have text.....
I used this formula, =COUNTA($C4:$F6)=12 but as you can see it only highlighted the top row???
I have no idea what I am doing wrong???
Sorry I can only load images not mini sheet from my work PC.