Conditional Formatting when all Fields = TRUE

JohnDadD

New Member
Joined
Apr 17, 2019
Messages
1
I am trying to change the border of a group of fields once all the fields contain the word TRUE. I was trying to set up a formula in Conditional Formatting but I do not know how.
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,382
set a formula in conditional formatting

select the range of cells - if say C2 to D20
then add a formula to conditional formatting =C2
and format to put a border round

that will put a border around the individual cells - not a group
I dont know how to do a group with just a border around the outside
 

Forum statistics

Threads
1,077,991
Messages
5,337,591
Members
399,156
Latest member
RaudMees

Some videos you may like

This Week's Hot Topics

Top