hi,
In worksheet Can we do like change color font if value in A1= 1, font color in range C1:D5 is black, and if no value in A1 color in range C1:D5 is white.
thanks in advance
herukuncahyono
hi,
In worksheet Can we do like change color font if value in A1= 1, font color in range C1:D5 is black, and if no value in A1 color in range C1:D5 is white.
thanks in advance
herukuncahyono
Last edited by herukuncahyono; 06-03-2010 at 03:34 AM.
Select c1:d5 - Menu Format- Conditional formatting
Formula is =$a$1=1 and set formatting as needed
hello arthurbr
great it work perfect
thanks for help
regards
herukuncahyono
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks