When a cell is empty, the "isblank(A1)" formula works fine.
But
If I enter a number of spaces, the formaula 1 (isblank) fails.
Here are my curent condtions
1) Formula - =IsBlank(J3) then background Yellow
2) Cell Value is - not equal to - =("OK") then Red
3) Cell Value is - equal to - ="OK" then Green
But
If I enter a number of spaces, the formaula 1 (isblank) fails.
Here are my curent condtions
1) Formula - =IsBlank(J3) then background Yellow
2) Cell Value is - not equal to - =("OK") then Red
3) Cell Value is - equal to - ="OK" then Green