liabilityquek
Member
I have created 3 conditional formatting rule for a column
=$G$2:$G$1048576 >1000 (Fill: Red)
=AND($G$2:$G$1048576>=500, $G$2:$G$1048576<=1000) (Fill: Amber)
=AND($G$2:$G$1048576>=1, $G$2:$G$1048576<=499) (Fill: Green)
The cell was highlighted whenever i enter the data. Please advise what would be the issue here.
Thanks in advance
=$G$2:$G$1048576 >1000 (Fill: Red)
=AND($G$2:$G$1048576>=500, $G$2:$G$1048576<=1000) (Fill: Amber)
=AND($G$2:$G$1048576>=1, $G$2:$G$1048576<=499) (Fill: Green)
The cell was highlighted whenever i enter the data. Please advise what would be the issue here.
Thanks in advance