Excel

[Closed]
Report
-
 Blocked Profile -
Hello,

i want to highlight a cell if there is no value in the cell.
I am using the isblank funtion in the excel but how do i set the color code .

if(isblank(A:A) , red,blue)

this is what i want, can some one advice on the right code.

1 reply


* Think of using polite forms.

* Remember behind each answer given on the forums, there are humans and volunteers who give part of their time trying to solve users' problems.
Therefore, it is expressly requested to kioskea forums users to show their utmost respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

* Please, re-write your message and post it in the appropriate forum :
https://ccm.net/contents/940-user-guide

Thank you for your understanding