excel - If a2 is not empty, color empty cells in b2:af2 -


would ple me below formula request in excel?

if a2 not empty, make empty cells red color in b2:af2, , apply rule a2:af5000

create cfr base upon following formula.

=and(len($a2), not(len(b2))) 

enter image description here


Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -