Google Docs Spreads...
 

Subscribe now and choose from over 30 free gifts worth up to ÂŁ49 - Plus get ÂŁ25 to spend in our shop

Google Docs Spreadsheet formatting.

5 Posts
5 Users
0 Reactions
93 Views
Posts: 0
Free Member
Topic starter
 

I'm no expert on spreadsheets, but in Excel I can format a cell B1 to be blue if cell A1 "is not empty". I can't seem to do this using conditional formatting in google docs, I cant import the spreadsheet as it wipes some of the formatting and I am stuck. Help me?


 
Posted : 02/09/2022 3:37 pm
Posts: 15212
Full Member
 

No help whatsoever but excel does seem to be more feature rich for this kinda thing.

Do you have a Hotmail /outlook webmail account?
You can open spreadsheets in that like a kind of excel 'lite'?


 
Posted : 02/09/2022 3:45 pm
Posts: 77687
Free Member
 

https://support.google.com/docs/answer/78413

Any particular reason that the answer isn't "use Excel, then"?


 
Posted : 02/09/2022 4:28 pm
Posts: 0
Free Member
Topic starter
 

There is, the collaboration that I have been hoiked into agaisnt my will are using google docs and it ain't my rodeo.


 
Posted : 02/09/2022 6:04 pm
Posts: 20
Full Member
 

You need a a custom formula, bottom option

=A1=""


 
Posted : 02/09/2022 7:41 pm
Posts: 14046
Free Member
 

I can’t seem to do this using conditional formatting in google docs

You definitely can in sheets.


 
Posted : 03/09/2022 1:04 am